Easy2Siksha.com
GNDU Question Paper-2021
B.A 1
st
Semester
COMPUTER SCIENCE
(Computer Fundamental & PC Software)
Time Allowed: Three Hours Max. Marks: 75
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-
1. (a) Discuss the components of a computer and their functions.
(b) Discuss the following Input devices: Mouse, OMR, Vision-input systems.
2. (a) Explain the following output devices: Monitors, Printers and Plotters.
(b) Discuss any two removable data storage devices.
SECTION-B
3. Discuss the following features of MS-Word: Table Formatting, Spell Checking, Border
and Shading.
4. (a) What are the steps required to implement mail-merge in MS-Word?
(b) Discuss the following features with usage in MS-Word:
(i) Templates and Wizards
(ii) Header and footer.
Easy2Siksha.com
SECTION-C
5. What is the use of MS-PowerPoint? Discuss various steps used in the creation of a
presentation in MS-PowerPoint?
6. Discuss the following features w.r.t. Microsoft PowerPoint:
(a) Various types of Views
(b) Slide show
(c) Printing slides.
SECTION-D
7. (a) How can multiple functions work together in Excel? Illustrate.
(b) How do you create and edit a graph in Excel?
8. Write short notes on the following features of MS-Excel?
(a) Querying the data
(b) Filtering the data
(c) What-if Analysis
(d) Sorting the data.
Easy2Siksha.com
GNDU Question Paper-2021
B.A 1
st
Semester
COMPUTER SCIENCE
(Computer Fundamental & PC Software)
Time Allowed: Three Hours Max. Marks: 75
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. (a) Discuss the components of a computer and their functions.
(b) Discuss the following Input devices: Mouse, OMR, Vision-input systems.
Ans: 1(a). Discuss the components of a computer and their functions
󻰿󻱀󻱁󻱂󷽳󻱃󼋥󻱅󼋦󻱆󻱇󼋧󼋨󻱈󻱉󻱊󼋩󻱋󻱌󻱍󼋪󼋫󼋬󼋭󻱎󻱏󻱐󻱑󻱒󻱓󻱔󻱕󻱖󼋮 Let’s Begin with a Story: The Magical Computer Team
Once upon a time in a tech kingdom, there was a powerful team known as the Computer
Team. This team worked together like a perfect machine. Each member had a special role,
and only when all the members worked together, magic happened the computer came
alive!
Let’s meet these team members one by one and learn their roles in a fun and easy way.
Diagram of Components of a Computer :
Easy2Siksha.com
󼨐󼨑󼨒 1. Central Processing Unit (CPU): The Brain of the Computer
The CPU is like the King of the team also called the brain of the computer.
Just like your brain tells your body what to do, the CPU tells the computer what to
do.
It processes all the instructions you give to the computer whether it’s playing a
song, typing a letter, or opening a game.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Functions:
Processes data.
Controls all other components.
Makes decisions and calculations quickly.
󼨻󼨼 Sub-parts of CPU:
1. ALU (Arithmetic Logic Unit) The Math Genius does all calculations.
2. CU (Control Unit) The Manager sends signals to other parts to do their work.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi types “2 + 2” and presses enter, the ALU quickly adds and gives the
answer “4”.
󹲨󹲭󹲩󹲪󹲫󹲬 2. Memory (RAM & ROM): The Thinkers of the Team
a) RAM (Random Access Memory): The Short-Term Memory
RAM is like your notebook where you write things temporarily.
It stores data only while the computer is on. Once off it forgets everything!
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Functions:
Temporarily holds data and instructions.
Helps CPU access data faster.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi opens MS Word, it gets stored in RAM so it can work quickly.
b) ROM (Read Only Memory): The Permanent Reminder
ROM is like a book of rules given to the computer when it is born.
It contains startup instructions that never change and are always there even when
the computer is off.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Functions:
Easy2Siksha.com
Stores permanent instructions (like booting the system).
Can only be read, not written easily.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi switches on his computer, ROM tells it how to start just like how
our body wakes up in the morning.
󹲣󹲤󹲥󹲦󹲧 3. Storage Devices: The Memory Bank
These are the parts where your computer saves all your files, photos, games, and
documents.
a) Hard Disk Drive (HDD) / Solid State Drive (SSD)
Think of these as lockers or storage rooms.
HDD is like an old-style cupboard, while SSD is like a modern drawer faster and
silent.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Functions:
Stores data permanently.
Keeps all your saved files.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi saves his homework, it goes into the HDD or SSD even if he
turns off the computer, it stays safe.
󼼈󼼉 4. Input Devices: The Messengers
These are the tools we use to tell the computer what to do.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Common Input Devices:
Keyboard to type.
Mouse to click.
Scanner to convert documents into digital form.
Mic to give voice commands.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: Ravi types a letter with a keyboard and draws using a mouse. These devices
carry his message to the CPU.
󺂌󺂍󺂎󺂏󺂐 5. Output Devices: The Speakers of the Team
Once the computer understands and processes what you told it, it needs a way to talk back
to you. That’s what output devices do!
Easy2Siksha.com
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Common Output Devices:
Monitor shows results (like your screen).
Printer gives results on paper.
Speakers play sound.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi finishes his drawing, it shows up on the monitor. When he prints it,
the printer gives him a paper copy.
󹸪󹸫󹸬 6. Motherboard: The Backbone
Imagine the Motherboard as the main road where all team members are connected. It is a
big circuit board where every component is fixed.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Functions:
Connects CPU, memory, storage, input-output devices.
Makes sure they all communicate properly.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi clicks the mouse, the signal goes to CPU through the motherboard.
󹸧󹸩󹸨 7. Power Supply Unit (PSU): The Life Giver
No team can work without energy. The PSU gives the electricity the computer needs to
come alive.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Function:
Converts electric power into usable energy for the computer.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: When Ravi plugs in the computer and presses the power button, the PSU
starts feeding energy to all parts.
󷆰 8. Ports and Cables: The Helpers
These are like doors and highways that help devices talk to each other.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Examples:
USB Port for pen drives.
HDMI Port for video display.
LAN Port for internet connection.
󷸎󷸏󷸐󷸑󷸒󷸓󷸔󷸙󷸕󷸚󷸖󷸛󷸜󷸝󷸗󷸘 Example: Ravi connects his printer to the computer through a USB port and the
printer starts working.
Easy2Siksha.com
󼪺󼪻 Summary Table
Component
Function
CPU
Brain of computer, processes all tasks
RAM
Temporary memory for fast access
ROM
Permanent memory for startup instructions
Storage (HDD/SSD)
Stores data permanently
Input Devices
Help give commands (e.g., keyboard, mouse)
Output Devices
Show results (e.g., monitor, printer)
Motherboard
Connects all parts together
Power Supply
Provides electricity to run the computer
Ports
Helps in connecting external devices
󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬 Final Thoughts
Understanding the components of a computer is like getting to know a well-coordinated
cricket team or a band every player has a special role. Whether it's the CPU as captain,
RAM as memory, or monitor as the announcer, they all must work together to complete
tasks.
So next time when you use a computer, remember: it's not just a machine, it's a magical
team working behind the screen!
(b) Discuss the following Input devices: Mouse, OMR, Vision-input systems.
Ans: (b) Discuss the following Input Devices: Mouse, OMR, Vision-input Systems
󷗐󷗑󷗒󷗓󷗔󷗕󷗖󷗗󷗘󷗙󷗚 Scene: A School Computer Lab Adventure
Let’s step into a school computer lab. It's a quiet Tuesday afternoon, and a group of
students from Class 9 is attending their computer class. Their teacher, Mrs. Mehta, walks in
with a big smile and says:
“Today, I’m not going to give you a boring lecture. Instead, we’re going on an adventure
inside a computer! We’ll meet three magical helpers who work hard to bring information
into your computer the Mouse, OMR, and Vision-Input System.”
Easy2Siksha.com
Excited, the students gather around as she begins the story...
󺂙󺂚 1. The Mouse The Magical Pointer
Imagine a little pet mouse that lives on your desk. But this isn’t an ordinary mouse it’s
your computer mouse, and it helps you talk to your computer using simple hand
movements.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 What It Does:
It is a pointing device.
It moves a cursor or pointer on your screen.
It allows you to click, drag, scroll, and open programs or files.
󼿝󼿞󼿟 How It Works:
When you move the mouse on your desk, a tiny sensor underneath tracks that movement
and tells the computer where the pointer should go on the screen.
There are two main types of mice:
1. Mechanical Mouse Has a ball inside it to detect movement (used in older
computers).
2. Optical Mouse Uses light sensors (modern mouse).
󷗭󷗨󷗩󷗪󷗫󷗬 Why It's Important:
It makes working with graphical interfaces (GUI) easy.
You can select items quickly and perform actions with just a click.
󼪺󼪻 2. OMR The Sheet Reader
Now let’s meet the second helper: OMR, which stands for Optical Mark Reader.
Mrs. Mehta tells the class, “Have you ever filled a multiple-choice answer sheet in an exam
by darkening circles with a pencil?”
The students nod eagerly.
“That sheet is read by a machine called OMR,” she explains.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 What It Does:
It reads marks made by pencil or pen on special printed forms.
It is mostly used in exams, surveys, or admission forms.
Easy2Siksha.com
󼿝󼿞󼿟 How It Works:
OMR uses light to scan the paper.
When it finds a darkened bubble, it reads it as a selected answer.
The answers are converted into digital form and sent to a computer.
󷪛󷪜󷪝󷪞󷪟󷪠󷪢󷪡 Example from Real Life:
Competitive exams like NEET, JEE, or school entrance tests use OMR sheets.
Thousands of answer sheets can be checked quickly using OMR.
󷗭󷗨󷗩󷗪󷗫󷗬 Why It's Important:
Saves time fast checking of answer sheets.
Reduces errors less human involvement.
High accuracy especially useful for large data collection.
󷵌󷵍󷵎󷵏󷵐󷵑 3. Vision-Input Systems The Eyes of the Computer
Now, the third helper appears. It’s not one specific device, but a group of devices that give
the computer the ability to see just like human eyes.
These are called Vision-Input Systems.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 What They Do:
They capture images or videos from the real world.
They help computers recognize faces, gestures, shapes, or text.
󼿝󼿞󼿟 How They Work:
A camera or scanner takes a photo or live video.
That visual data is converted into digital signals.
The computer then uses Artificial Intelligence (AI) or image processing software to
analyze the input.
󷩦󷩧󷩨󷩩󷩪󷩫󷩬󷩭󷩮 Where Are They Used?
Face recognition for phone unlocking or airport security.
Self-driving cars use vision systems to detect roads, obstacles, and signs.
Medical scans like X-rays or MRIs are processed using vision systems.
Augmented reality (like Snapchat filters or gaming apps) also uses these systems.
Easy2Siksha.com
󷗭󷗨󷗩󷗪󷗫󷗬 Why They Matter:
They help in automation and AI-based tasks.
They allow machines to see, interpret, and respond just like humans.
They are key in modern technologies like robotics, surveillance, and healthcare.
󷕘󷕙󷕚 A Quick Recap Let’s Meet the Three Helpers Again!
Device
Full Form
What It Does
Key Usage
󺂙󺂚 Mouse
Moves pointer, allows
clicking
All computer tasks
󼪺󼪻 OMR
Optical Mark
Reader
Reads marked sheets
Exams, surveys
󷵌󷵍󷵎󷵏󷵐󷵑 Vision-Input
Systems
Captures and analyzes
images
AI, security,
healthcare
󼨐󼨑󼨒 A Memory Trick:
M Mouse = Moves cursor
O OMR = Observes answer sheets
V Vision system = Views the world
So just remember “MOVe” — Mouse, OMR, Vision!
󹵅󹵆󹵇󹵈 Conclusion
By the end of the class, all students were smiling. They didn’t just memorize definitions
they met the characters, understood their roles, and saw how input devices are a bridge
between humans and machines.
These three devices the Mouse, OMR, and Vision-input system show us how technology
listens to us, reads what we mark, and even learns to see like us.
And just like in Ravi’s story earlier, these “magical helpers” are always working behind the
scenes to make your computer smart, interactive, and useful!
Easy2Siksha.com
2. (a) Explain the following output devices: Monitors, Printers and Plotters.
(b) Discuss any two removable data storage devices.
Ans: 󷗐󷗑󷗒󷗓󷗔󷗕󷗖󷗗󷗘󷗙󷗚 Once Upon a Time in Computer land...
In the magical world of Computer land, there lived a brilliant computer named Compy.
Compy was super smart. He could solve problems, calculate numbers, and store loads of
data. But there was one problem he couldn’t speak to humans directly.
So, the King of Computer land decided to give Compy some special helpers who could
communicate his thoughts to the human world.
These helpers were called Output Devices. And among the most famous of them were:
󷇴󷇵󷇶󷇷󷇸󷇹 Monitors
󺂑󺂒󺂓󺂔󺂕󺂖󺂗󺂘 Printers
󺁤󺁥󺁦󺁧󺁨 Plotters
Let’s meet each of them and understand how they help the computer “speak” to us in the
real world.
󺂌󺂍󺂎󺂏󺂐 1. Monitor The Visual Storyteller
The Monitor was the most talkative of all output devices.
Think of a monitor as the eyes of the computer for humans. Just like we watch TV or scroll
on our phone screens, a monitor shows us what the computer is doing.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 What is a Monitor?
A monitor is an output device that displays text, images, videos, and user interfaces on a
screen. It is one of the most essential parts of any computer setup.
When you:
Open a file,
Watch a movie,
Play a game,
Or type in MS Word...
Easy2Siksha.com
…it’s the monitor that visually presents all of this to you.
󼨐󼨑󼨒 Real-Life Example:
Imagine if you typed an email and had no way to see what you were writing how would
you know if you made a mistake? That’s the monitor’s job to give you a live window into
the computer’s brain.
󼨽󼨾󼨿󼩁󼩀 Types of Monitors:
CRT (Cathode Ray Tube) Old, bulky monitors like old TV screens.
LCD (Liquid Crystal Display) Thin, flat-screen monitors used today.
LED (Light Emitting Diode) More advanced, brighter and energy-saving screens.
Touchscreen Monitors Let you interact directly by touching the screen.
The monitor is like a stage, and everything the computer does is like a performance that we
watch.
󺂑󺂒󺂓󺂔󺂕󺂖󺂗󺂘 2. Printer The Paper Magician
Then there was the Printer, the magician who could turn digital files into real paper copies.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 What is a Printer?
A printer is an output device that transfers information from the computer onto paper
this is called a hard copy.
Whether it's:
Notes from class,
A boarding pass,
Or your favorite photo…
…the printer takes the digital data and magically makes it appear on physical paper.
󼨐󼨑󼨒 Real-Life Example:
If Ravi finishes a school project on the computer and wants to submit it to his teacher, he
uses the printer to get a printed copy.
󼨽󼨾󼨿󼩁󼩀 Types of Printers:
1. Inkjet Printer
o Sprays tiny drops of ink on paper.
o Good for colorful pictures.
Easy2Siksha.com
o Used at home or in small offices.
2. Laser Printer
o Uses a laser beam and toner.
o Very fast and sharp quality.
o Perfect for printing a lot of pages quickly.
3. Dot Matrix Printer
o Makes marks using pins and ink ribbon.
o Noisy and old-fashioned, but still used for carbon copies (like bill receipts).
4. Thermal Printer
o Uses heat to print.
o Mostly used in ATMs, supermarkets, etc.
The printer is like a bridge it connects the digital world of the computer to the real world
of paper.
󺁤󺁥󺁦󺁧󺁨 3. Plotter The Master Artist
And finally, there was the Plotter the most artistic and precise of all.
While monitors show things on-screen, and printers print standard-sized pages, plotters are
used when huge, highly detailed drawings are needed.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 What is a Plotter?
A plotter is an output device that draws images on paper using pens. It is used for large-
scale printing and technical drawings.
󼨐󼨑󼨒 Real-Life Example:
Architects use plotters to print big blueprints of buildings. Engineers use them for circuit
diagrams or mechanical parts. Artists use them for design posters or maps.
󼨽󼨾󼨿󼩁󼩀 Types of Plotters:
1. Drum Plotter
o The paper is wrapped around a drum that moves as the pen draws.
2. Flatbed Plotter
o The paper is fixed, and the pens move over the surface.
Plotters don’t just print, they draw with precision like a robot artist!
Easy2Siksha.com
󷑢󷑣󷑤󷑥 Let’s Wrap It Up Like a Story Summary
In the kingdom of Computer land:
The Monitor shows us what’s happening inside the computer, like a screen
performance.
The Printer gives us a paper version of the computer’s thoughts like a paper
messenger.
The Plotter draws beautiful, large, and detailed technical artwork like an
engineer’s assistant.
All three are output devices because they take information from the computer and send it
out to us either visually (monitor), physically (printer), or artistically (plotter).
(b) Discuss any two removable data storage devices.
Ans: Once Upon a Time in the Digital World…
In a world full of data pictures, videos, assignments, games, and memories there lived
a young student named Aarav. Aarav loved photography and often clicked hundreds of
pictures with his digital camera. One day, his phone ran out of space. His laptop was almost
full too. He began to panic. “Where do I store all this data?” he thought.
Just then, his elder sister Riya smiled and handed him a small device from her bag. “Meet
your data superheroes,” she said, “the removable storage devices. They’re small but
powerful. Let me introduce you to two of them your future saviors!”
Let’s meet them one by one — like characters in a movie!
󷕒󷕓󷕔󷕕󷕖󷕗 1. USB Flash Drive (Pen Drive) The Pocket-Sized Genius
Riya took out a small device no bigger than a keychain.
“This,” she said, “is a USB Flash Drive. Most people call it a pen drive.”
Aarav looked surprised. “But it’s so small!”
“Yes,” she replied, “but don’t judge it by its size.”
󹳴󹳵󹳶󹳷 What is a USB Flash Drive?
A USB flash drive is a portable, removable storage device that uses flash memory to store
data. It connects to computers, TVs, or other devices through a USB port (Universal Serial
Bus).
Easy2Siksha.com
It can store, transfer, and delete data just like a mini hard drive.
󽄻󽄼󽄽 Key Features:
Small and portable fits in your pocket or even hangs on your keyring.
No moving parts which makes it durable and less likely to break.
Plug-and-play Just insert it into the USB port, and it's ready to use.
Storage capacities From 2GB to even 1TB nowadays.
󹴮󹴯󹴰󹴱󹴲󹴳 Real-life Use Case (Aarav’s Story)
Riya told Aarav: “Imagine you want to show your photography project at school. Just copy
your photos into this pen drive, take it with you, and plug it into the school computer. No
internet required!”
Aarav's eyes sparkled. “This is amazing! It’s like carrying a tiny backpack full of memories!”
󹲮󹲰󹲱 2. CD/DVD The Shiny Circle of the Past (But Still Useful)
Next, Riya opened a drawer and showed Aarav a shiny disc. It looked like something from a
science fiction movie.
“This,” she said, “is a DVD. Earlier, we used CDs too. They are optical storage devices.”
󹳴󹳵󹳶󹳷 What are CDs and DVDs?
CD stands for Compact Disc.
DVD stands for Digital Versatile Disc or Digital Video Disc.
They are flat, round discs made of plastic, used to store data, music, movies,
software, and more.
You read or write data on them using a laser beam inside a CD/DVD drive.
󽄻󽄼󽄽 Key Features:
CDs can store about 700MB of data.
DVDs can store 4.7GB (single-layer) or more.
Lightweight and portable.
Can be write-once (CD-R/DVD-R) or rewriteable (CD-RW/DVD-RW).
Easy2Siksha.com
Easy to label and store in cases.
󹴮󹴯󹴰󹴱󹴲󹴳 Real-life Use Case (Aarav’s Story Continues)
“Long before pen drives became popular,” Riya explained, “we stored movies, music, and
even games on CDs and DVDs. I still have your childhood videos on this DVD!”
Aarav inserted the disc into their computer’s DVD drive. A video popped up baby Aarav
dancing in diapers!
They both burst into laughter.
󺮛󺮗󺮜󺮝󺮗󺮘󺮙󺮚󺮞󺮟 Why Are These Devices Called “Removable”?
Aarav asked curiously, “Why do we call them removable?”
Riya smiled: “Because you can insert and remove them from a computer or device anytime.
You don’t need to open the machine or connect permanently. That’s what makes them easy
and convenient.”
SECTION-B
3. Discuss the following features of MS-Word: Table Formatting, Spell Checking, Border
and Shading.
Ans: 󷇴󷇵󷇶󷇷󷇸󷇹 Title: Riya’s Journey Through the Magical World of MS Word
Once upon a time in a small town, there lived a schoolgirl named Riya. She had a big dream
to become a teacher and help students learn in creative ways. One day, her computer
teacher gave her an assignment: “Riya, create a beautiful document using MS Word and
explain how to use Table Formatting, Spell Checking, Border, and Shading.”
Riya felt nervous. She had used MS Word before but never explored it deeply. So, she
decided to treat this as a little adventure.
Let’s follow Riya as she explores each of these magical tools in MS Word!
󼨻󼨼 1. Table Formatting Turning Rows and Columns into Magic
Riya started by creating a time-table for her imaginary school. She clicked on Insert > Table
and added 5 rows and 4 columns. But wait! It looked plain, just black-and-white lines. Not
something that would impress her teacher.
So, she used the Table Formatting options.
Easy2Siksha.com
She clicked on the table, and "Table Design" tab appeared like a magic wand.
There she saw:
Table Styles colorful and ready-made table designs.
Header Row she ticked this to make the first row bold and colored.
Banded Rows it made alternate rows shaded, making it easier to read.
She even used the "Layout" tab to:
Adjust column widths and row heights.
Align text to the center.
Split or merge cells as needed.
󹳴󹳵󹳶󹳷 Tip from Riya: “Use Table Formatting to make your data clear, colorful, and
professional. It helps readers understand your table easily.”
󹸯󹸭󹸮 2. Spell Checking The Red Lines that Save Us!
Next, Riya wrote a paragraph about her dream school. But as she typed quickly, she made
spelling mistakes.
She noticed some words had red squiggly lines under them.
“Oh no! I made spelling errors,” she said.
She right-clicked on the underlined word and saw suggestions for correct spelling. With one
click, the word was corrected.
She also used the Review > Spelling & Grammar option. This opened a pane that guided her
through all the spelling and grammar issues in the whole document.
󹳴󹳵󹳶󹳷 Pro Tip by Riya: “Never submit your work without using Spell Check. It catches silly
mistakes and improves your marks!”
󷖳󷖴󷖵󷖶󷖷 3. Border Giving Your Document a Frame
Riya wanted her title “Welcome to My Dream School” to stand out. So, she selected the text
and added a border around it.
She went to Home > Borders (it looks like a little window icon).
She clicked on:
Outside Borders to frame the text.
Then selected Borders and Shading for more options:
Easy2Siksha.com
o Changed the line style (dotted or double line).
o Picked a color (blue to match the school theme).
o Increased the width of the line.
She even added page borders by going to Design > Page Borders and selecting an artistic
border that looked like notebook edges.
󹳴󹳵󹳶󹳷 Note from Riya: “Borders help highlight important parts. Use them wisely to make your
content stand out!”
󺁮󺁯󺁰 4. Shading Adding Color Without a Brush
To make her document colorful, Riya used Shading. She wanted the table heading and key
points to pop out.
She selected the cells or text, then went to:
Home > Shading (paint bucket icon).
Chose a light yellow for headings and light blue for important notes.
She discovered that:
Shading adds background color to text or tables.
It makes the content look organized and vibrant.
Unlike highlighting, shading stays even when printing.
󹳴󹳵󹳶󹳷 Advice from Riya: “Use soft colors so the content is readable. Don’t overdo it!”
󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬 Riya's Final Document
By the end of her magical journey, Riya’s document had:
A neat, colorful table with proper formatting,
No spelling mistakes,
Beautiful borders around important text and pages,
Eye-pleasing shading that made everything pop!
When she submitted the assignment, her teacher said:
"Riya, this is not just a document it’s a work of art!"
Easy2Siksha.com
4. (a) What are the steps required to implement mail-merge in MS-Word?
Ans: 󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬 A Birthday Party and a Surprise Lesson on Mail Merge!
Once upon a time in a small town, there lived a college student named Nisha. She was
known for being creative and tech-savvy. One day, she decided to throw a birthday party for
her classmates. She wanted to invite each of them with a personalized letter that had their
name, roll number, and a sweet birthday message.
But when she opened MS Word and saw she had to write 45 different letters, she said,
There must be a better way!
That’s when her elder brother, Raj, a computer teacher, walked in and said,
“Nisha, you don’t need to type the same letter 45 times. Just use something called Mail
Merge in MS Word!”
󹨹󹨺󹨻 What is Mail Merge?
Mail Merge is a powerful feature in Microsoft Word that lets you create multiple
personalized letters, labels, emails, or envelopes by combining a single document (like an
invitation letter) with a data source (like a list of names and addresses).
In simple words:
You write one letter and Word does the magic of creating many, by pulling details from a
list.
Now Nisha got curious.
“Okay Bhaiya, then tell me step-by-step how I can do this mail merge!”
Let’s walk through what Raj taught Nisha in simple steps.
󷃆󼽢 Steps to Implement Mail Merge in MS Word
󹻂 Step 1: Open Microsoft Word and Create Your Main Document
First, open a blank document or a pre-written letter in MS Word.
󹲹󹲺󹲻󹲼󹵉󹵊󹵋󹵌󹵍 Example:
Dear [Name],
You are invited to my birthday party on 15th August at my home. Your roll number is
[RollNumber]. Hope to see you there!
This is called the Main Document. It contains the fixed text that stays the same in every
copy.
Easy2Siksha.com
󹻂 Step 2: Go to the “Mailings” Tab
Now go to the “Mailings” tab at the top of the screen.
There, you will find a group of options specially made for mail merge.
Click on “Start Mail Merge” and choose “Step-by-Step Mail Merge Wizard” if you want
guided help.
This makes it super easy.
󹻂 Step 3: Select the Type of Document
Word will now ask you, “What do you want to create?”
Options include:
Letters
Emails
Labels
Envelopes
Directory
Nisha chose Letters since she was creating invitation letters.
Click Next after selecting.
󹻂 Step 4: Choose Starting Document
Here, you tell Word which document you’re using.
You have 3 choices:
Use the current document (your open file),
Start from a template,
Or open an existing document.
Nisha selected “Use the current document” and clicked Next.
󹻂 Step 5: Select Recipients (Data Source)
This step is very important.
Now you select the data list that has the personal details of your recipients.
Easy2Siksha.com
Options:
Use an existing list (Excel file)
Select from Outlook contacts
Type a new list
Nisha didn’t have a file yet, so she clicked “Type a new list”.
A small window popped up, and she entered:
First Name
Aarti
Ramesh
Suman
Then she clicked “OK” and saved the list as a .mdb file (Microsoft database).
󹻂 Step 6: Insert Merge Fields
Now the real magic begins!
Nisha clicked where she wanted to insert personalized data in her letter and chose “Insert
Merge Field.”
She selected:
First Name where she wanted the name
Roll Number where she wanted the roll number
So her letter looked like this:
Dear <<First_Name>>,
You are invited to my birthday party. Your roll number is <<Roll_Number>>. See you soon!
󹻂 Step 7: Preview Your Letters
This step lets you see how each personalized letter will look.
Just click “Preview Results” in the Mailings tab.
Nisha saw:
Dear Aarti,
You are invited...
Then clicked the arrow → to see:
Easy2Siksha.com
Dear Ramesh,
You are invited...
And so on. She was so excited!
󹻂 Step 8: Complete the Merge
Once everything looked perfect, she clicked “Finish & Merge” and chose:
Print Documents to directly print all letters
OR
Edit Individual Documents to generate a new file with all merged letters
She chose to edit first, saved the file, and later printed the letters.
Done! 󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬
󷇴󷇵󷇶󷇷󷇸󷇹 Why Mail Merge is Super Useful?
1. Saves hours of repetitive typing.
2. Ensures zero mistakes in names or numbers.
3. Looks professional and neat.
4. Great for:
o Sending invitations
o Making hall tickets
o Creating certificates
o Personalized marketing letters
(b) Discuss the following features with usage in MS-Word:
(i) Templates and Wizards
(ii) Header and footer.
Ans: Once upon a time, there was a college student named Aarav who had a problem.
His English teacher gave him a task:
“Create a formal report using MS Word. Make it neat, professional, and consistent!”
Easy2Siksha.com
Aarav was confused. He knew how to type in Word, but didn’t know how to make it look
perfect with the same font, neat headings, and page numbers. He asked his elder sister,
Meera, who was great at using computers.
She smiled and said, “Don’t worry, let me show you some magic tools inside MS Word. Let’s
begin your journey with something called Templates and Wizards.”
󽄻󽄼󽄽 (i) Templates and Wizards Your Ready-Made Helpers
Imagine if you had to design a birthday card or a resume from scratch every time where
would you begin? What colors? What layout? What font? Aarav got nervous just thinking
about it.
That’s when Meera opened MS Word and clicked on File → New.
“There you go,” she said. “Templates are like pre-designed documents. All you need to do is
fill in the blanks.”
󷽰󷽱󸚌󷽲󷽳󷽴󷽵󷽶󸚍󷽷󸚎󸚏󷽸󷽹󸚐󷽺󷽻󸚑󸚒󷽼󷽽󷽾󷽿󷾀󷾁󷾂󷾃󷾄󷾅󷾆󷾇󷾈󷾉󸚓 Definition:
A Template is a pre-formatted document in MS Word which you can use to create new
documents with the same structure. Instead of designing a new document every time, just
choose a template and start typing!
󷿶󷿷󷿸󷿹󷿺󸚾󷻱󷿼󸚿󷿾󸛀󷻴󷿑󸛁󸛂󷾴󷾸󸛃󷿿󷾵󸛄󷾶󸛅󸀀󸛆󸛇󷾷󸛈󷾹󸀁󸀂 Real Use:
Aarav wanted to make a report. So, he selected a Report Template. The headings, font style,
spacing everything was already neatly arranged. He just added his content!
󹵅󹵆󹵇󹵈 Other templates you can use:
Resumes
Letters
Brochures
Certificates
Newsletters
󹰤󹰥󹰦󹰧󹰨 Wizards, on the other hand, were popular in older versions of MS Word.
They acted like step-by-step guides. They asked a few questions like “What’s the title?” or
“Do you want a cover page?” — and then created the document based on your answers.
Even though modern versions have fewer Wizards, the concept remains inside features like
Mail Merge Wizard, which helps you send personalized emails or letters to many people
using a step-by-step process.
󷗭󷗨󷗩󷗪󷗫󷗬 Benefits of Templates and Wizards:
Easy2Siksha.com
Save Time You don’t start from scratch.
Look Professional Designs are polished and neat.
Maintain Consistency Fonts, margins, styles stay the same.
After using the report template, Aarav’s document looked much better. But something was
missing.
“There’s no name or date on top,” he said.
Meera smiled again and said, “It’s time for the second magic tool — Headers and Footers!”
󼪺󼪻 (ii) Header and Footer Your Page’s Identity Cards
Imagine reading a book. On every page, you see the book title or chapter name at the top,
and the page number at the bottom. That’s not written by hand — it’s the Header and
Footer in action.
󷽰󷽱󸚌󷽲󷽳󷽴󷽵󷽶󸚍󷽷󸚎󸚏󷽸󷽹󸚐󷽺󷽻󸚑󸚒󷽼󷽽󷽾󷽿󷾀󷾁󷾂󷾃󷾄󷾅󷾆󷾇󷾈󷾉󸚓 Definition:
A Header is the space at the top of each page in a document, and a Footer is the space at
the bottom.
You can use these areas to add:
Page numbers
Document title
Author name
Date
Logos
󹴡󹴵󹴣󹴤 How Aarav Used It:
He double-clicked at the top of the page and typed:
Report on Environmental Pollution
Aarav Sharma B.Com 3rd Semester
Then he scrolled down it appeared on every page.
At the bottom, he inserted page numbers using:
Insert → Page Number → Bottom of Page
Now each page looked like it belonged to the same professional document!
󺫦󺫤󺫥󺫧 Uses of Header and Footer in Real Life:
󹴮󹴯󹴰󹴱󹴲󹴳 In books: You’ll often see chapter names and page numbers.
Easy2Siksha.com
󹲹󹲺󹲻󹲼 In reports: Institution name, department, and student info are placed in
headers/footers.
󹲽󹲾󹲿󹳀󹳁󹳂󹳃󹳈󹳄󹳅󹳆󹳇 In invoices: Company logo and contact info are in headers/footers.
󹰤󹰥󹰦󹰧󹰨 Tips to Remember:
You can have different headers on the first page by checking “Different First Page” in
the design tab.
You can insert date and time, page numbers, or even images (like logos) in the
header/footer.
Headers and footers make your document professional, organized, and complete.
󹳴󹳵󹳶󹳷 Aarav’s Final Thoughts
After adding the header, footer, and using a smart template, Aarav submitted his report.
The teacher said, “Wow! This is clean, consistent, and beautifully formatted. Full marks!”
Aarav was proud. He realized that MS Word isn’t just for typing. It’s a powerful tool — and
with features like Templates, Wizards, Header, and Footer, you can make any document
look like it was made by a professional designer.
SECTION-C
5. What is the use of MS-PowerPoint? Discuss various steps used in the creation of a
presentation in MS-PowerPoint?
Ans: 󷇴󷇵󷇶󷇷󷇸󷇹 Let’s Begin With a New Story…
Once upon a time in a small town, there was a student named Ananya. She was very smart
but had one big feargiving class presentations. Whenever her teacher said, “Next week
you will present your project in front of the class,” Ananya would panic.
But one day, her elder brother, Arjun, introduced her to something that changed her life
MS PowerPoint. He said, “Don’t worry! This tool will help you speak with confidence. You’ll
impress everyone!”
Let’s follow Ananya’s journey to understand what MS PowerPoint is used for, and how she
created her first ever presentation step by step!
Easy2Siksha.com
󹲙󹲚󹲛󹲜󹲝󹲞 What is MS PowerPoint?
Microsoft PowerPoint is a presentation software that helps you create slides with text,
images, animations, videos, and more to visually support your talk or story.
In simple words:
PowerPoint is like a digital notebook with pages (called slides) where you can put your ideas
and explain them using pictures, words, and effects.
Whether it's a school project, a college seminar, a business plan, or even a wedding
invitation, PowerPoint makes your ideas look smart and interesting.
󼨐󼨑󼨒 Uses of MS PowerPoint (Why it is Useful)
󷕘󷕙󷕚 For Students:
Present school or college projects.
Explain complex topics with diagrams and animations.
Gain confidence in public speaking.
󹲟󹲠󹲡󹲢 For Professionals:
Present business ideas to clients or bosses.
Conduct training or workshops with visuals.
Share reports, data, and future plans.
󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬 For Everyone:
Create photo albums or storybooks.
Design invitations or digital greeting cards.
Even teach online with interactive slides!
󷖳󷖴󷖵󷖶󷖷 Now, Let’s See How Ananya Created Her First Presentation!
󼮹󼮺󼮻󼮼󼮽󼮾 Step-by-Step Guide to Creating a Presentation in MS PowerPoint
Step 1: Open MS PowerPoint
Ananya clicked on the Start Menu → Searched PowerPoint → Clicked on it to open a blank
slide.
Easy2Siksha.com
It looked like a white board with space to write a title and a subtitle. That was her starting
point.
Step 2: Choose a Design/Theme
Ananya didn’t want a boring white slide. So she clicked on the “Design” tab and saw many
beautiful themes.
She selected a blue and white theme with modern fonts. Now her slides looked attractive
and professional.
󷖳󷖴󷖵󷖶󷖷 Themes make your presentation look clean and consistent.
Step 3: Add Slides and Write Content
She clicked “New Slide” from the Home tab to add more slides.
First Slide: Title “My Science Project on Solar System”
Second Slide: She wrote about the Sun.
Third Slide: She described each planet with bullet points.
󹰤󹰥󹰦󹰧󹰨 She used short and clear text because slides are for highlights, not paragraphs.
Step 4: Insert Pictures and Charts
To make it fun, she clicked on the “Insert” tab, and added:
A picture of the solar system
A chart comparing planet sizes
A short video of a rocket launch
󷖥󷖦󷖩󷖧󷖨 Visuals helped her audience understand better and stay interested.
Step 5: Use Animations and Transitions
Then she went to the “Animations” tab and added cool effects like:
The planets flying in one by one
Text appearing with a bounce
Each slide changing smoothly using the “fade” transition
󽄻󽄼󽄽 These effects made her presentation feel like a movie.
Easy2Siksha.com
Step 6: Add Speaker Notes
Ananya wasn’t confident about remembering everything. So she used the “Notes” section
below each slide to write what she wanted to say.
That way, during the presentation, she could glance at the screen and remember her points.
󹳬󹳭󹳮󹳯󹳰󹳳󹳱󹳲 Speaker Notes = secret helper!
Step 7: Save and Rehearse
She clicked File → Save As → Named it “Solar System Presentation.”
Then she practiced in front of the mirror. She used the “Slideshow” button to view her slides
in full screen just like her audience would see.
Step 8: Present with Confidence
On the day of the presentation, Ananya used the projector, opened her file, and clicked on
“From Beginning” in the Slideshow tab.
As the slides changed, her classmates watched with interest, her teacher smiled, and for the
first time Ananya spoke with confidence.
6. Discuss the following features w.r.t. Microsoft PowerPoint:
(a) Various types of Views
(b) Slide show
(c) Printing slides.
Ans: 󷇴󷇵󷇶󷇷󷇸󷇹 PowerPoint: A Magical Stage for Presentations
Imagine you’re a stage director preparing a grand school play. You have actors (your
content), stage arrangements (slides), rehearsals (slide show), and even printed scripts for
the backstage crew (printed slides).
Just like that, when you're preparing a presentation in Microsoft PowerPoint, you're not just
putting words on a screen you're designing an experience for your audience. PowerPoint
gives you all the tools needed to create, view, present, and even print your content
beautifully.
In this magical journey, let’s explore three main things:
1. Different Types of Views
2. Slide Show (Presentation Time!)
Easy2Siksha.com
3. Printing Slides (The Hard Copies)
So, grab your digital director's cap, and let's begin.
󷗛󷗜 (a) Various Types of Views in Microsoft PowerPoint
Let’s start with a small story.
󼏨󼏩󼏪󼏫󼏬󷸓󼏭󼏮󷸕󼏯󷸖󼏰󼏱󼏲󼏳󼏴 Meet Ria The Presentation Expert
Ria is a college student who has to present a project in class. She opens Microsoft
PowerPoint and sees so many buttons and options. But something interesting catches her
eye the "View" tab. She clicks on it and enters a whole new world where she can look at
her presentation in different ways, depending on what she wants to do.
This is what Views are different ways to see and work on your presentation. Just like a
director watches the play from backstage, front row, or even from the lighting booth,
PowerPoint gives you multiple views to manage your slides.
Let’s understand them one by one.
󽄻󽄼󽄽 1. Normal View
󹸯󹸭󹸮 This is the default view when you open PowerPoint. It’s like your work desk.
On the left, there’s a panel showing all your slides in order.
In the center, you see the selected slide and can edit it.
Below, there's a space to write notes (helpful while presenting).
󹳴󹳵󹳶󹳷 Ria’s Use: Ria uses this view to add text, insert images, and design each slide. It’s her go-
to working space.
󽄻󽄼󽄽 2. Slide Sorter View
󹴖󹴗󹴘󹴙󹴚󹴛 This shows all your slides as small thumbnails (mini images).
You can easily drag and drop to reorder slides.
Great for checking the flow of the presentation.
󹳴󹳵󹳶󹳷 Ria’s Use: Before presenting, Ria uses this to rearrange her slides and check if the story
flows well.
Easy2Siksha.com
󽄻󽄼󽄽 3. Reading View
󹴮󹴯󹴰󹴱󹴲󹴳 This view plays the slide show in a window (not full screen).
Good for quickly checking animations or how the slide looks.
Useful if you want to test your slides without switching modes.
󹳴󹳵󹳶󹳷 Ria’s Use: Ria uses this when she wants to preview slides while working on other things.
󽄻󽄼󽄽 4. Slide Show View
󷗐󷗑󷗒󷗓󷗔󷗕󷗖󷗗󷗘󷗙󷗚 This is the actual presentation mode.
Full-screen display.
All animations, transitions, and timings work exactly as they will during the real
presentation.
󹳴󹳵󹳶󹳷 Ria’s Use: Ria uses this for the final rehearsal before she presents in front of her class.
󽄻󽄼󽄽 5. Outline View
󹲹󹲺󹲻󹲼󹵉󹵊󹵋󹵌󹵍 Shows just the text content of all slides no images or design.
Helps focus only on content structure.
Good for reviewing headings and points.
󹳴󹳵󹳶󹳷 Ria’s Use: When Ria wants to check if she has included all important points or missed
something, this is her go-to view.
󽄻󽄼󽄽 6. Notes Page View
🗒 This shows how the slide will look with speaker notes.
Slides appear on the top half of the page.
Speaker notes appear below.
󹳴󹳵󹳶󹳷 Ria’s Use: Ria prints these pages to use as a cheat sheet while presenting.
󽄻󽄼󽄽 Summary Table Views at a Glance
View Name
Purpose
Looks Like
Normal View
Create and design slides
Edit workspace
Easy2Siksha.com
Slide Sorter
Rearranging slides
Mini-slide thumbnails
Reading View
Preview slides in a window
Window slideshow
Slide Show View
Present full-screen
Live show
Outline View
Text-only structure
Text outline
Notes Page View
Review slides with notes
Slide + Notes
󷖥󷖦󷖩󷖧󷖨 (b) Slide Show
Now comes the exciting part the actual presentation, or as we call it in PowerPoint the
Slide Show.
Let’s go back to Ria’s story.
󷇴󷇵󷇶󷇷󷇸󷇹 Ria's Big Presentation Day
The classroom lights dim. Ria walks to the front of the class. Her heart is racing. She opens
her PowerPoint file, presses F5, and her carefully designed slides fill the screen.
This is the Slide Show mode where all your preparation finally comes alive.
󷗐󷗑󷗒󷗓󷗔󷗕󷗖󷗗󷗘󷗙󷗚 What is a Slide Show?
A Slide Show is the full-screen view where you present your slides one by one in front of an
audience.
It includes animations, transitions, sound, and videos.
It’s the mode where you actually deliver your presentation.
How to Start a Slide Show?
1. Press F5 Starts from the first slide.
2. Press Shift + F5 Starts from the current slide.
3. Go to the Slide Show tab on the ribbon and click “From Beginning” or “From Current
Slide.”
󷃆󹸃󹸄 Navigation Tools During Slide Show
During the show, you can:
Easy2Siksha.com
Press Right Arrow / Enter / Mouse click to move to the next slide.
Press Left Arrow / Backspace to go back.
Press Esc to exit the show.
Use laser pointer, pen, or highlighter tools (Right-click → Pointer Options).
󼨐󼨑󼨒 Tips Ria Used in Her Slide Show
She kept bullet points short and used images to support them.
She practiced with timings and animations.
She used transitions like Fade and Push to keep things smooth.
She added speaker notes to help her remember key points.
󼨽󼨾󼨿󼩁󼩀 Advanced Slide Show Features
1. Set Up Slide Show You can customize how your slideshow runs (manual or timed).
2. Rehearse Timings PowerPoint helps you practice and records how long you spend
on each slide.
3. Custom Slide Shows Choose a few slides (not all) to create a shorter version of
your full show.
󺂑󺂒󺂓󺂔󺂕󺂖󺂗󺂘 (c) Printing Slides
After her successful presentation, Ria’s teacher says, “Please submit a printed copy of your
slides.”
This is where PowerPoint’s Print feature becomes useful.
󹲹󹲺󹲻󹲼 What Can You Print in PowerPoint?
1. Full Page Slides One slide per page.
2. Handouts Multiple slides (2, 3, 6, or 9) on one page.
3. Notes Pages Each page shows the slide along with your speaker notes.
4. Outline View Only the text content, no design.
󺂑󺂒󺂓󺂔󺂕󺂖󺂗󺂘 Steps to Print Slides
Easy2Siksha.com
1. Click File → Print.
2. Select Printer.
3. Under Settings, choose what to print:
o Slides
o Handouts
o Notes Pages
o Outline
4. Choose number of copies.
5. Click Print.
󹴷󹴺󹴸󹴹󹴻󹴼󹴽󹴾󹴿󹵀󹵁󹵂 Ria’s Smart Printing Choices
She printed Handouts (3 slides per page) It included lines next to each slide so
classmates could take notes.
She printed Notes Pages for herself as a reference copy.
She printed Outline View for her teacher to review content.
󼪺󼪻 Why is Printing Useful?
Handouts help the audience follow along.
Notes Pages help speakers remember talking points.
Outline makes content easy to review and grade.
Full Slides are useful for submitting official documents or portfolios.
󹲹󹲺󹲻󹲼󹵉󹵊󹵋󹵌󹵍 Final Summary Table
Feature
What It Does
Best Used For
Views
Shows slides in different formats
Editing, sorting, previewing
Slide Show
Full-screen presentation mode
Delivering your presentation
Printing Slides
Print slides in different formats
Submitting, sharing, reviewing
󷕘󷕙󷕚 Conclusion Your Stage, Your Show
Easy2Siksha.com
Microsoft PowerPoint is not just a tool, it’s like a digital stage where you’re the director,
designer, and presenter all in one.
The Views help you set the stage.
The Slide Show lets you perform.
And Printing ensures your audience and teacher get takeaway material.
Ria’s journey through PowerPoint shows how using these features smartly can turn a boring
presentation into a memorable and impressive performance.
SECTION-D
7. (a) How can multiple functions work together in Excel? Illustrate.
(b) How do you create and edit a graph in Excel?
Ans: 7 (a) How can multiple functions work together in Excel? Illustrate.
󷇴󷇵󷇶󷇷󷇸󷇹 Once Upon a Spreadsheet...
In the small town of DataVille, there lived a girl named Ananya. She was a bright student
and loved organizing things. One day, her teacher gave her a challenge:
“Ananya, I want you to calculate the performance of 50 students using Excel but you have
to use multiple functions together, not just simple addition.”
Ananya smiled, opened her laptop, and said, “Let’s make Excel dance!”
This story is about **how Ananya learned to make different Excel functions work together
like a team and how YOU can too!
󹰤󹰥󹰦󹰧󹰨 What Does It Mean to Combine Functions in Excel?
In Excel, you can use one function like SUM() to add numbers. But Excel becomes truly
powerful when you combine multiple functions in a single formula.
This is called nesting functions or combining functions.
Think of it like this:
“One function prepares the data, another function processes it, and a third one presents it.”
Just like in a cricket team:
One player throws the ball,
Easy2Siksha.com
Another catches it,
And a third one runs to hit the stumps.
Together, they win the game.
󼨐󼨑󼨒 Let’s Understand with a Simple Example First
Ananya had a list of student marks in cells A2 to A11. She wanted to know:
The average of the scores,
But she also wanted to round off the result,
And then add a remark saying “Pass” or “Fail” based on the result.
So, she used this magical Excel formula:
=IF(ROUND(AVERAGE(A2:A11), 0) >= 40, "Pass", "Fail")
Let’s break it down:
1. AVERAGE(A2:A11) → Calculates the average of the marks.
2. ROUND(..., 0) → Rounds the average to the nearest whole number.
3. IF(... >= 40, "Pass", "Fail") → Checks if the rounded average is 40 or more. If yes,
returns "Pass", else "Fail".
So here, three functions (IF, ROUND, and AVERAGE) are working together like a team to give
a final answer.
󼿝󼿞󼿟 How Functions Work Together (Step-by-Step Thinking)
When you use multiple functions in Excel:
1. Innermost function runs first (like AVERAGE in the example).
2. Its result is passed to the next function (ROUND).
3. Then, that output goes to the final function (IF), which makes the decision.
This process is just like cooking:
You first chop the vegetables (first function),
Then boil or fry them (second function),
Finally, serve with spices (third function).
󽄻󽄼󽄽 Real-Life Scenario: Using Multiple Functions
Easy2Siksha.com
Let’s go deeper with another example from Ananya’s Excel adventure.
She had this table:
Name
Marks1
Marks2
Marks3
Ravi
45
60
55
Sneha
90
92
88
Arjun
30
25
28
She wanted to do the following:
Add all three marks
Find the average
Round it to 2 decimal places
Give "Excellent", "Good", or "Fail" based on the average
She used this amazing Excel formula:
=IF(ROUND(AVERAGE(B2:D2),2)>=75,"Excellent",IF(ROUND(AVERAGE(B2:D2),2)>=40,"Good"
,"Fail"))
󷵻󷵼󷵽󷵾 Here’s how it works:
1. AVERAGE(B2:D2) → Calculates average marks of 3 subjects.
2. ROUND(...,2) → Rounds the result to 2 decimal places.
3. IF(...,"Excellent",...) → First checks if average ≥ 75.
4. IF(...,"Good","Fail") → If not, checks if average ≥ 40.
5. Returns the final result: "Excellent", "Good", or "Fail".
This is a beautiful example of function nesting, where each layer adds more intelligence.
󺫦󺫤󺫥󺫧 Why Use Multiple Functions Together?
󹳴󹳵󹳶󹳷 Save Time: One formula can do the job of five!
󹳴󹳵󹳶󹳷 Improve Accuracy: You avoid manual steps.
󹳴󹳵󹳶󹳷 Automate Logic: Great for handling data rules (like grading, discounts, salary
slips).
󹳴󹳵󹳶󹳷 Dynamic Sheets: If data changes, the results change automatically.
Easy2Siksha.com
󹺊 More Examples of Functions Working Together
󹳸󹳺󹳹 Example 1: Extracting and Cleaning Data
=PROPER(TRIM(A1))
󷵻󷵼󷵽󷵾 TRIM(A1) removes extra spaces from the name
󷵻󷵼󷵽󷵾 PROPER(...) converts “ravi kumar” to “Ravi Kumar”
󹳸󹳺󹳹 Example 2: Date and Time Formatting
=TEXT(TODAY(),"dddd, dd-mmm-yyyy")
󷵻󷵼󷵽󷵾 TODAY() gives today’s date
󷵻󷵼󷵽󷵾 TEXT(...,"format") changes the look: “Tuesday, 30-Jul-2025”
󹳸󹳺󹳹 Example 3: Combining Text and Numbers
="Total Marks: "&SUM(B2:B6)
󷵻󷵼󷵽󷵾 Joins text and the sum of marks into one sentence
󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬 Final Thoughts: Be Like Ananya
By the end of her assignment, Ananya was not only done early her sheet was neat,
smart, and interactive. Her teacher was so impressed that she showed Ananya’s file to the
whole class!
“When you combine Excel functions,” said her teacher, “you turn a simple spreadsheet into
a mini software.”
So remember:
SUM adds power,
IF adds logic,
TEXT, ROUND, VLOOKUP, and others all can work together like superheroes in your
spreadsheet.
8. Write short notes on the following features of MS-Excel?
(a) Querying the data
(b) Filtering the data
(c) What-if Analysis
Easy2Siksha.com
(d) Sorting the data.
Ans: 󷗐󷗑󷗒󷗓󷗔󷗕󷗖󷗗󷗘󷗙󷗚 A Day in the Life of Riya The Excel Explorer
Once upon a time, in a small town in India, lived a smart and curious college student named
Riya. She wasn’t a tech genius, but she had a deep love for learning new things. One day,
her professor gave her an assignment on MS-Excel. She had to prepare and analyze some
data for a local NGO working with underprivileged children.
Riya opened her laptop, took a deep breath, and entered the World of Excel not just to
type numbers, but to understand how Excel can query, filter, sort, and analyze data just like
a super-intelligent assistant!
󼨐󼨑󼨒 (a) Querying the Data Asking the Sheet Smart Questions
Think of querying like asking Excel a question about your data. Riya had a large table with
hundreds of students’ records — name, age, class, marks, attendance, etc. She didn’t want
to scroll endlessly.
So, she asked herself:
"Can I find only those students who scored more than 80 marks and have more than 90%
attendance?"
󷇴󷇵󷇶󷇷󷇸󷇹 That’s where Querying comes in!
󷵻󷵼󷵽󷵾 What is Querying?
Querying means searching and retrieving specific data from a large dataset based on some
conditions.
In Excel, this can be done using:
Advanced Filters
Power Query
SQL Queries in Microsoft Query tool
󹺊 How Riya Did It:
1. She selected her data table.
2. Went to Data > Get & Transform > Launch Power Query Editor.
3. In Power Query, she applied a filter:
o Marks > 80
o Attendance > 90%
4. Excel instantly gave her the list she needed!
Easy2Siksha.com
󷓠󷓡󷓢󷓣󷓤󷓥󷓨󷓩󷓪󷓫󷓦󷓧󷓬 She saved time and looked smart. No more endless scrolling.
󼨻󼨼 Real-Life Example:
Imagine you’re in a library. There are 5000 books. If you want only fiction books published
after 2015, would you check every book? No! You’d ask the librarian — like querying Excel.
"Hey Excel, show me only the data I need!"
That’s querying.
󼪭󼪮󼪯󼪰󼪱󼪲󼪳󼪴󼪵󼪶󼪷󼪸󼪹 (b) Filtering the Data Like a Data Strainer
Riya then noticed something.
Her Excel table was still big. She didn’t need to apply complex conditions this time — she
just wanted to quickly hide and show certain rows. Like:
Show only students from Class 10
Show only those who are female
Show only absent students
She discovered another magical tool: Filter.
󷵻󷵼󷵽󷵾 What is Filtering?
Filtering means displaying only the rows that match a certain condition while hiding the rest
without deleting anything.
Excel's Filter tool is available in the Home or Data tab.
󹺊 How Riya Did It:
1. She selected the whole data table.
2. Clicked Data > Filter.
3. Small arrows appeared in the column headers.
4. She clicked the arrow in "Gender" and selected Female only.
5. Boom! Excel only showed female students. Everyone else was hidden (but still
there).
She filtered again by class, by attendance, by marks all just a few clicks away.
󷏹󷏺󷏻󷏼 Real-Life Analogy:
Easy2Siksha.com
Think of it like a tea strainer. You pour everything in, but only tea flows out, and the tea
leaves are held back.
Just like that, in Excel:
You keep all the data in place,
But only the rows you want are visible.
Filtering = Hiding the noise, showing only what matters.
Riya loved this feature. She felt like she was making Excel dance!
󺮛󺮗󺮜󺮝󺮗󺮘󺮙󺮚󺮞󺮟 (c) What-if Analysis The Magic of Prediction
Now came the tricky part.
The NGO head told Riya:
"We want to know what will happen if we increase the food budget per child by ₹50?
How will that affect our total budget?"
Riya was puzzled.
This wasn’t just data — this was prediction. It was time for some What-If Analysis.
󷵻󷵼󷵽󷵾 What is What-If Analysis?
What-if Analysis is a powerful feature in Excel that lets you change input values to see how
the outcome changes.
It’s used for:
Forecasting budgets
Decision-making
Scenario analysis
󼩣󼩤󼩥󼩦󼩧󼩨󼩩 Excel’s What-if Tools:
1. Data Tables
2. Goal Seek
3. Scenario Manager
󼨽󼨾󼨿󼩁󼩀 How Riya Used Them:
Easy2Siksha.com
Goal Seek:
She had a formula:
Total Budget = Number of Children × Budget per Child
She wanted the total budget to be ₹2,00,000. So she asked:
"What should be the per-child budget to make the total ₹2,00,000?"
1. Clicked Data > What-If Analysis > Goal Seek.
2. Set the total budget cell to ₹2,00,000.
3. Selected budget per child cell to change.
4. Excel calculated the required value!
Scenario Manager:
Riya created three budget plans:
Low Budget
Medium Budget
High Budget
She saved them as scenarios using Scenario Manager and compared them side by side.
Data Table:
She created a table showing different outcomes for per-child budget ranging from ₹100 to
₹500.
Excel updated the total budget automatically for every row real-time magic!
󼨻󼨼 Real-Life Analogy:
Think of it like a calculator that thinks ahead.
Suppose your father says,
"If you get 90% in exams, I’ll buy you a bike. What if you get 85%?"
He’s doing a what-if analysis in his mind.
Excel does the same but with instant math and accurate results.
What-if = Planning + Prediction + Preparation
󹳨󹳤󹳩󹳪󹳫 (d) Sorting the Data Organizing the Chaos
Finally, Riya wanted her data to look neat and easy to read.
Easy2Siksha.com
She had random entries. She wanted:
Names in alphabetical order
Marks in highest to lowest
Dates in oldest to newest
That’s where Sorting came in.
󷵻󷵼󷵽󷵾 What is Sorting?
Sorting means arranging data in a specific order ascending or descending based on one
or more columns.
󹲣󼩪󼩫󼩬󼩭󼩲󼩳󼩮󼩯󼩰󼩱 Types of Sorting:
1. Text Sorting A to Z or Z to A
2. Number Sorting Smallest to Largest or Largest to Smallest
3. Date Sorting Oldest to Newest or vice versa
4. Custom Sorting You decide the order
󹺊 How Riya Did It:
1. Selected the entire table.
2. Went to Data > Sort.
3. Chose:
o Sort by Name → A to Z
o Sort by Marks → Largest to Smallest
Excel rearranged everything in perfect order like books arranged neatly on a shelf.
󼨻󼨼 Real-Life Analogy:
Ever tried finding your favorite shirt in an unorganized wardrobe?
But if your clothes are sorted by color, type, or season, you find it instantly.
That’s what sorting does to data — it creates order from chaos.
󷕘󷕙󷕚 Final Reflection: Excel Isn’t Just a Tool — It’s a Thinking Assistant!
Easy2Siksha.com
By the end of her assignment, Riya had:
Queried the right data
Filtered unnecessary rows
Sorted the information beautifully
Predicted future scenarios with What-if Analysis
She submitted her Excel file to the professor.
Her professor smiled and said:
"Riya, this is not just data work this is intelligent analysis. Well done!"
“This paper has been carefully prepared for educational purposes. If you notice any mistakes or
have suggestions, feel free to share your feedback.”